Hello All, Sorry - I know it's long to read but Please take look if you have some time. Thanks very much in Advance. I have a view that shows dollar amounts for "This Month", "Next Month" and "Third Month". Every end of the month I have to go to this view and adjust the dates for the months mentioned above. Please take a look at my code below, I am close but still not working like it should. Current Code Below @If (ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "90%"; netrevenue * 0.9 ; ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "80%"; netrevenue * 0.8 ; ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "60%"; netrevenue * 0.6 ; ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "40%"; netrevenue * 0.4 ; ftim_CloseDate >= [01/01/2003] & ftim_CloseDate <= [01/31/2003] & fnum_Probability = "20%"; netrevenue * 0.2 ; "") My code attempt below to select automaticlly the "Third Month" firstday := @Adjust(@Date(@Year(@Now); @Month(@Now);1); 0; 2; 0; 0; 0; 0); @Adjust(firstday; 0; 0; 0; 0; 0; 0); lastday := @Adjust(@Date(@Year(@Now); @Month(@Now);1); 0; 3; 0; 0; 0;0); @Adjust(lastday; 0; 0; -1; 0; 0; 0); @If (ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "90%"; netrevenue * 0.9 ; ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "80%"; netrevenue * 0.8 ; ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "60%"; netrevenue * 0.6 ; ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "40%"; netrevenue * 0.4 ; ftim_CloseDate >= firstday & ftim_CloseDate <= lastday & fnum_Probability = "20%"; netrevenue * 0.2 ; "")
Go back